Tabela DgPack

Definicja tabeli DgPack

Name

DgPack

Code

DgPack

Comment

informacje o opakowaniach leków


Lista kolumn tabeli DgPack

Name

Code

PackID

PackID

DrugDBTypeID

DrugDBTypeID

ExternalID

ExternalID

DrugID

DrugID

Active

Active

Name

Name

EAN

EAN


Kolumna PackID tabeli DgPack

Definicja kolumny PackID tabeli DgPack

Name

PackID

Code

PackID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID opakowania leku


Kolumna DrugDBTypeID tabeli DgPack

Definicja kolumny DrugDBTypeID tabeli DgPack

Name

DrugDBTypeID

Code

DrugDBTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ExternalID tabeli DgPack

Definicja kolumny ExternalID tabeli DgPack

Name

ExternalID

Code

ExternalID

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna DrugID tabeli DgPack

Definicja kolumny DrugID tabeli DgPack

Name

DrugID

Code

DrugID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID leku


Kolumna Active tabeli DgPack

Definicja kolumny Active tabeli DgPack

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

 


Kolumna Name tabeli DgPack

Definicja kolumny Name tabeli DgPack

Name

Name

Code

Name

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna EAN tabeli DgPack

Definicja kolumny EAN tabeli DgPack

Name

EAN

Code

EAN

Data Type

VARCHAR2(32)

Mandatory

No

Comment

kod EAN opakowania (European Article Number)


Lista kluczy tabeli DgPack

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli DgPack

Definicja klucza Identifier_1 tabeli DgPack

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment